import pandas as pd
import numpy as np

df1=pd.read_excel('非洲通讯产品销售数据.xlsx',sheet_name='SalesData')
df2=pd.read_excel('非洲通讯产品销售数据.xlsx',sheet_name='SalespersonData')



df1[df1['利润']==0]=np.nan
df1_new=df1.dropna()
df1_new.to_excel('SalesData处理版.xlsx')
